Skip to main content Skip to complementary content
Qlik Resources

Setting up Landing Zone and Data Source connections

This section explains how to set up landing zone and data source connectivity in a Qlik Compose project. Note that although you must configure landing zone connectivity, data source connectivity is only required if you want to discover the source database defined in the Replicate task.

For a list of the pros and cons of discovering the source database as opposed to the landing zone, see Discovering the Source Database or Landing Zone.

Reserved column names and suffixes

The following section lists the reserved column names and suffixes. If the any of the discovered tables contain columns with these names or suffixes, you need to rename them in Compose. For information on renaming columns, see Managing attributes.

Reserved column names:

  • ID
  • BIR_MAPPING_NR - internal mapping identifier used in staging tables for ETL
  • ROWNR - internal row identifier used in staging tables for ETL
  • RUNNO_INSERT - The task run number for INSERT operations.
  • RUNNO_UPDATE - The task run number for UPDATE operations.
  • OBSOLETE__INDICATION - Used to mark OBSOLETE records in data mart objects. See also: The "Obsolete" indicator
  • TR_ID - The unique Transaction ID for a fact table record.
  • BID_OCCS - Internal column used in ETL processing.

  • FD - This column is added to tables that contain attributes (columns) with a History Type 2. The column is used to delimit the range of dates for a given record version. The column name can be changed in the project settings.

    Information noteIf you change the "From Date" name in the project settings, the new name will become a reserved word.

  • TD - This column is added to tables that contain attributes (columns) with a History Type 2. The column is used to delimit the range of dates for a given record version. The column name can be changed in the project settings.

    Information noteIf you change the "To Date" name in the project settings, the new name will become a reserved word.
  • FKNR - Foreign key number column used in logging tables to report missing references captured via the data warehouse ETL

Reserved suffixes in data darts:

  • _OID
  • _VID

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here